How to Use the Import Queue

The Import Queue lists all of the trial balance filesA trial balance file should contain a single trial balance. The records within the trial balance should at least have a reporting unit, general ledger account code, beginning balance (optional), and ending balance. that have been added to General Ledger Manager and that await import into the application or other disposition. The list of files is sorted in ascending alphanumeric order by trial balance file name. You can click the File column heading to toggle the list between ascending and descending alphanumeric order. You can also sort the list by Arrival Date/Time of the files on the queue by clicking in this column heading.

The name of the File, the Arrival Date/Time of the file in the Import Queue, and format validation status is displayed for each trial balance file on the Import Queue.

Importing trial balance files into General Ledger Manager is a two-step process in which trial balance files must first be added to the Import Queue and then, if they pass file format validation, you can importTo bring a valid trial balance file into the General Ledger Manager database from the Import Queue. In the import process, only the trial balance data in the file gets brought into the database. them. The Import Queue also enables you to do both of these functions.

In addition to viewing and searching the list of trial balances, you can do all of the following in the Import Queue:

• Add a trial balance file by:

1. Clicking Add a File to Queue
2. Selecting the trial balance file that you want to add.
3. Selecting a chart of accountsNumbered lists of accounts, including the account codes and their names/descriptions, that make up the general ledgers of companies and that form the bases of trial balances. In General Ledger Manager, you must create a chart of accounts for each trial balance file that you will upload. To each chart of accounts, you must attach an import layout for each trial balance file. The charts of accounts and their import layouts will be applied to their respective trial balance files for file validation when the files are added to the application. and an import layoutAn import layout contains the unique file attributes of a trial balance file(s). These attributes include the delimiter used in the file and the starting row of its data. Also included are the column numbers/letters where the required trial balance data fields reside. Administrators assign import layouts to charts of accounts, and both are used together by the application to validate trial balance files as they are uploaded to the Import Queue. with which to upload the trial balance file.

Each time you add a trial balance file, General Ledger Manager returns you to the Import Queue where you can see the newly added file in the list along with its validation results.

• Import valid trial balance files into General Ledger Manager.
• Compare and review a trial balance file on the Import Queue to one that has already been imported into General Ledger Manager.
• Control the list view by Sorting the list.
• Download a trial balance file.
• Delete a trial balance file.